package com.bgi.uims.pub.utils;


/**
 * 
 * ClassName: Constant <br/>
 * Function: TODO 静态常量. <br/>
 * Reason: TODO ADD REASON(可选). <br/>
 * date: 2014-10-20 下午02:04:45 <br/>
 *
 * @author fukun
 * @version 
 * @since JDK 1.7
 */
public class Constant {
	//SQL ID
	/**
	 * 角色管理
	 */
	public static final String SQL_QUERY_ROLES = "querySysRoles";
	public static final String SQL_QUERY_ROLES_BYIDS = "querySysRolesByIds";
	public static final String SQL_INSERT_ROLES="insertSysRoles";
	public static final String SQL_UPDATE_ROLES="updateSysRoles";
	public static final String SQL_DELETE_ROLES="deleteSysRoles";
	public static final String SQL_QUERY_VERIFYSYSROLESNAME="verifySysRolesName";
	public static final String SQL_QUERY_ROLESBYID = "querySysRolesById";
	public static final String SQL_QUERY_SYSROLE_PORTAL = "querySysRolePortal";
	public static final String SQL_DELETE_ROLES_PORTAL="deleteRolePortal";
	public static final String SQL_SAVE_ROLES_PORTAL="saveRolePortal";
	public static final String SQL_SAVE_ROLES_MENU_BYROLEID="deleteRoleMenuById";
	public static final String SQL_SAVE_ROLES_USER_BYROLEID="deleteRoleUserById";
	public static final String SQL_SAVE_ROLES_RESOURCE_BYROLEID="deleteRoleResourceById";
	public static final String SQL_SAVE_ROLES_PORTAL_BYROLEID="deleteRolePortalById";
	/**
	 * 系统类型
	 */
	public static final String SQL_QUERY_SYSTEM = "querySysSystem";
	public static final String SQL_INSERT_SYSTEM="insertSysSystem";
	public static final String SQL_UPDATE_SYSTEM="updateSysSystem";
	public static final String SQL_DELETE_SYSTEM="deleteSysSystem";
	public static final String SQL_QUERY_VERIFY_SYSTEMNAME="verifySysSystemName";
	public static final String SQL_QUERY_VERIFY_SYSTEMCODE="verifySysSystemCode";
	
	public static final String SQL_QUERY_SYSTEMBYID = "querySysSystemById";
	
	/**
	 * 面板管理
	 */
	public static final String SQL_QUERY_PORTAL = "queryPortal";
	public static final String SQL_INSERT_PORTAL="insertPortal";
	public static final String SQL_UPDATE_PORTAL="updatePortal";
	public static final String SQL_DELETE_PORTAL="deletePortal";
	public static final String SQL_DELETE_PORTALRELATION="deletePortalRelation";
	public static final String SQL_QUERY_VERIFY_PORTALNAME="verifyPortalName";
	public static final String SQL_QUERY_VERIFY_PORTALCODE="verifyPortalCode";
	public static final String SQL_QUERY_PORTALBYID = "queryPortalById";
	public static final String SQL_UPDATE_PORTALSTATUS = "updatePortalState";
	public static final String SQL_QUERY_DESKTOPBYUSER = "queryDesktopByUser";
	public static final String SQL_QUERY_DESKTOPBYUSERS = "queryDesktopByUsers";
	public static final String SQL_QUERY_NOTINROLE = "queryPortalNotInRole";
	public static final String SQL_QUERY_BYROLE = "queryPortalByRole";
	public static final String SQL_INSERT_USERDESKTOP = "insertUserDesktop";
	public static final String SQL_UPDATE_USERDESKTOP = "updateUserDesktop";
	
	/**
	 * 系统公告
	 */
	public static final String SQL_QUERY_NOTICE = "queryNotice";
	public static final String SQL_INSERT_NOTICE="insertNotice";
	public static final String SQL_UPDATE_NOTICE="updateNotice";
	public static final String SQL_DELETE_NOTICE="deleteNotice";
	public static final String SQL_QUERY_VERIFY_NOTICENAME="verifyNoticeName";
	public static final String SQL_QUERY_NOTICEBYID = "queryNoticeById";
	public static final String SQL_QUERY_NEW_NOTICE = "getNewNoticeInfo";
	
	/**
	 * 用户管理
	 */
	public static final String SQL_QUERY_USER = "queryUser";
	public static final String SQL_INSERT_USER="insertUser";
	public static final String SQL_UPDATE_USER="updateUser";
	public static final String SQL_DELETE_USER="deleteUser";
	public static final String SQL_DELETE_USERROLES="deleteUserRoles";
	public static final String SQL_DELETE_USERPORTAL="deleteUserPortal";
	public static final String SQL_QUERY_VERIFY_USERNAME="verifyUserName";
	public static final String SQL_QUERY_VERIFY_WORKNUM="verifyWorkNun";
	public static final String SQL_QUERY_VERIFY_EMAIL="verifyEmail";
	public static final String SQL_QUERY_USERBYID = "queryUserById";
	public static final String SQL_UPDATE_USERSTATUS = "updateUserState";
	public static final String SQL_UPDATE_USERLASTTIME = "updateLastTime";
	public static final String SQL_INSERT_USERROLE = "insertUserRole";
	public static final String SQL_QUERY_USERROLES = "queryUserRoles";
	public static final String SQL_QUERY_ROLESID="queryRolesId";
	public static final String SQL_QUERY_USERBYUSERNAME="queryUserByUserName";
	public static final String SQL_QUERY_USER_ROLESID_BYUSERID="queryUserRolesIdByUserId";
	public static final String SQL_UPDATE_LOGINUSERCOUNT="updateLoginUserCount";
	public static final String SQL_QUERY_LOGINUSERCOUNT="queryLoginUserCount";
	
	/**
	 * 登录日志
	 */
	public static final String SQL_QUERY_LOGIN = "querylogin";
	public static final String SQL_INSERT_LOGINLOG = "insertlogin";
	public static final String SQL_UPDATE_LOGINLOG = "updatelogin";
	
	/**
	 * 组织架构
	 */
	public static final String SQL_QUERY_DEPARTMENT = "queryDepartment";
	public static final String SQL_QUERY_DEPARTMENTBYID = "queryDepartmentById";
	public static final String SQL_QUERY_DEPARTMENT_ASSOCIATE = "queryDepartmentAssociate";
	public static final String SQL_QUERY_LOWER_DEPARTMENT_ASSOCIATE = "queryLowerDepartmentAssociate";
	public static final String SQL_QUERY_DEPARTMENT_BYCODE = "queryDepartmentByCode";
	public static final String SQL_QUERY_DEPARTMENT_BYNAME = "queryDepartmentByName";
	public static final String SQL_QUERY_DEPARTMENT_CONDITION = "queryDepartmentByCondition";  
	public static final String SQL_UPDATE_DEPARTMENT = "updateDepartment";
	public static final String SQL_UPDATE_DEPARTMENT_STATUS = "updateDepartmentState";
	public static final String SQL_INSERT_DEPARTMENT = "insertDepartment";
	public static final String SQL_DELETE_DEPARTMENT = "deleteDepartment";
	
	/**
	 * 菜单管理
	 */
	public static final String SQL_QUERY_ALLMENU = "queryAllMenu";
	public static final String SQL_QUERY_USERMENU = "queryUserMenu";
	public static final String SQL_QUERY_MENU_BYIDS = "queryMenuByIds";
	public static final String SQL_QUERY_MENU_BYROLE = "queryMenuByRole";
	public static final String SQL_INSERT_MENU = "insertMenu";
	public static final String SQL_UPDATE_MENU = "updateMenu";
	public static final String SQL_QUERY_MENUBYID = "queryMenuById";
	public static final String SQL_DELETE_MENU_ROLE = "deleteMenuRoles";
	public static final String SQL_DELETE_MENU = "deleteMenu";
	public static final String SQL_QUERY_MENURESOURCECOUNT = "queryMenuResourceCount";
	public static final String SQL_UPDATE_RESOURCE = "updateResource";
	public static final String SQL_INSERT_RESOURCE = "insertResource";
	public static final String SQL_DELETE_RESOURCE_ROLE = "deleteResourceRoles";
	public static final String SQL_DELETE_RESOURCE = "deleteResource";
	public static final String SQL_QUERY_RESOURCEBYID = "queryResourceById";
	public static final String SQL_QUERY_RESOURCE = "queryResourceByMenuId";
	public static final String SQL_QUERY_ROLE_RESOURCE = "queryRoleResourceByMenuId";
	public static final String SQL_DELETE_ROLEPURVIEWS = "deleteRolePurviews";
	public static final String SQL_INSERT_ROLEPURVIEWS = "insertRolePurviews";
	public static final String SQL_DELETE_ROLERESOURCE = "deleteRoleResources";
	public static final String SQL_QUERY_RESOURCE_BYIDS = "queryResourceByIds";
	public static final String SQL_INSERT_ROLERESOURCE = "insertRoleResources";
	public static final String SQL_QUERY_DISABLEDRESOURCEBYUSERID = "queryDisabledResourceByUserId";
	/**
	 * 操作日志
	 */
	public static final String SQL_QUERY_OPERATOR = "queryoperatorLog";
	public static final String SQL_QUERY_DATA_OPERATOR = "queryDataOperatorLog";
	public static final String SQL_INSERT_OPERATOR = "insertoperatorLog";
	public static final String SQL_LOG_OPERATOR_INSERT = "insertCommonOperatorLog";
	
	//其他标示
	public static final String STSTIC_URL_LOGINUSER = "/login";
	public static final String STSTIC_URL_INDEX = "/index.jsp";
	public static final String STSTIC_URL_CALLMSG = "/sys/callMsg";
	public static final String LOGINUSER = "loginUser";
	public static final String DISABLEDRESOURCENAME = "disabledResourceName";
	public static final String DISABLEDRESOURCEURL = "disabledResourceUrl";
	public static final String LOGINLOG_ID = "loginLogId";
	public static final String SESSIONS = "sessions";
	public static final String ERRORINFO = "errorInfo";
	public static final String LOGIN_INPUTVCODE = "inputVcode";
	public static final String LOGIN_VCODE = "vcode";
	public static final String ROWS = "rows";
	public static final String PAGE = "page";
	public static final String MSG = "msg";
	public static final String ERROR_CODE_101 = "101";
	public static final String ERROR_CODE_102 = "102";
	public static final String ERROR_CODE_103 = "103";
	public static final String ERROR_CODE_104 = "104";
	public static final String ERROR_CODE_105 = "105";
	public static final char INSERT = 'i';
	public static final char UPDATE = 'u';
	public static final char DELETE = 'd';
	public static final char SELECT = 's';
	public static final String OPERATIONMSG = "operationMsg";
	public static final String DEAULT_DATETIME = "1900-01-01 00:00:00";
	
	/**
	 * 记录模块
	 */
	public static final String ROLEMODULES = "角色管理";
	public static final String USERMODULES = "用户管理";
	public static final String PORTALMODULES = "面板管理";
	public static final String LOGINLOGMODULES = "登录日志";
	public static final String OPERATORLOGMODULES = "操作日志";
	public static final String DEPARTMENTMODULES = "组织管理";
	public static final String MENUMODULES = "菜单管理";
	public static final String SYSTEMMODULES = "系统管理";
	public static final String NOTICEMODULES = "系统公告";
}